{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"provenance":[],"collapsed_sections":["7dafXWCMujav"],"authorship_tag":"ABX9TyPuwlBu5KS5aTBCsBQUsYnR"},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"}},"cells":[{"cell_type":"markdown","source":["# MovieLens Dataset"],"metadata":{"id":"hSaOgBx-q5bj"}},{"cell_type":"code","source":["import numpy as np\n","import pandas as pd"],"metadata":{"id":"H-ruJRCurlFT"},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":["Mounting google drive and loading data"],"metadata":{"id":"2ukKIKQdrBow"}},{"cell_type":"code","source":["# mount the drive content to google colab\n","from google.colab import drive\n","drive.mount('/content/drive')"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"R7FwmBCdrRnE","executionInfo":{"status":"ok","timestamp":1714752424514,"user_tz":-180,"elapsed":20987,"user":{"displayName":"Mostafa Touny","userId":"03224802388069779869"}},"outputId":"6e11feb2-7c17-48c2-9504-a39df5e1399f"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Mounted at /content/drive\n"]}]},{"cell_type":"code","source":["# columns are movies ids\n","# cells are user's rating for the corresponding movie\n","df = pd.read_csv(\"/content/drive/MyDrive/Spring 2024 - Math with Applications/MTH106 Linear Algebra/Project/user-movie-rating.csv\")\n","df"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":423},"id":"5v-T89q1ra2z","executionInfo":{"status":"ok","timestamp":1714752429134,"user_tz":-180,"elapsed":3615,"user":{"displayName":"Mostafa Touny","userId":"03224802388069779869"}},"outputId":"74156fff-9102-443e-f1b3-bb9bf0b94c88"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["     userId    1    2    3   4   5    6    7   8   9  ...  193565  193567  \\\n","0         1  4.0  NaN  4.0 NaN NaN  4.0  NaN NaN NaN  ...     NaN     NaN   \n","1         2  NaN  NaN  NaN NaN NaN  NaN  NaN NaN NaN  ...     NaN     NaN   \n","2         3  NaN  NaN  NaN NaN NaN  NaN  NaN NaN NaN  ...     NaN     NaN   \n","3         4  NaN  NaN  NaN NaN NaN  NaN  NaN NaN NaN  ...     NaN     NaN   \n","4         5  4.0  NaN  NaN NaN NaN  NaN  NaN NaN NaN  ...     NaN     NaN   \n","..      ...  ...  ...  ...  ..  ..  ...  ...  ..  ..  ...     ...     ...   \n","605     606  2.5  NaN  NaN NaN NaN  NaN  2.5 NaN NaN  ...     NaN     NaN   \n","606     607  4.0  NaN  NaN NaN NaN  NaN  NaN NaN NaN  ...     NaN     NaN   \n","607     608  2.5  2.0  2.0 NaN NaN  NaN  NaN NaN NaN  ...     NaN     NaN   \n","608     609  3.0  NaN  NaN NaN NaN  NaN  NaN NaN NaN  ...     NaN     NaN   \n","609     610  5.0  NaN  NaN NaN NaN  5.0  NaN NaN NaN  ...     NaN     NaN   \n","\n","     193571  193573  193579  193581  193583  193585  193587  193609  \n","0       NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN  \n","1       NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN  \n","2       NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN  \n","3       NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN  \n","4       NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN  \n","..      ...     ...     ...     ...     ...     ...     ...     ...  \n","605     NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN  \n","606     NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN  \n","607     NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN  \n","608     NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN  \n","609     NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN  \n","\n","[610 rows x 9725 columns]"],"text/html":["\n","  <div id=\"df-00d23434-2bec-4f8b-9c34-6d90039d3a63\" class=\"colab-df-container\">\n","    <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>userId</th>\n","      <th>1</th>\n","      <th>2</th>\n","      <th>3</th>\n","      <th>4</th>\n","      <th>5</th>\n","      <th>6</th>\n","      <th>7</th>\n","      <th>8</th>\n","      <th>9</th>\n","      <th>...</th>\n","      <th>193565</th>\n","      <th>193567</th>\n","      <th>193571</th>\n","      <th>193573</th>\n","      <th>193579</th>\n","      <th>193581</th>\n","      <th>193583</th>\n","      <th>193585</th>\n","      <th>193587</th>\n","      <th>193609</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>4.0</td>\n","      <td>NaN</td>\n","      <td>4.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>4.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>3</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>4</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>5</td>\n","      <td>4.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>605</th>\n","      <td>606</td>\n","      <td>2.5</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>2.5</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>606</th>\n","      <td>607</td>\n","      <td>4.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>607</th>\n","      <td>608</td>\n","      <td>2.5</td>\n","      <td>2.0</td>\n","      <td>2.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>608</th>\n","      <td>609</td>\n","      <td>3.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>609</th>\n","      <td>610</td>\n","      <td>5.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>5.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>610 rows × 9725 columns</p>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-00d23434-2bec-4f8b-9c34-6d90039d3a63')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-00d23434-2bec-4f8b-9c34-6d90039d3a63 button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-00d23434-2bec-4f8b-9c34-6d90039d3a63');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-9d10ae43-b913-46df-b1d4-49ce14e9b2cb\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-9d10ae43-b913-46df-b1d4-49ce14e9b2cb')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-9d10ae43-b913-46df-b1d4-49ce14e9b2cb button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"],"application/vnd.google.colaboratory.intrinsic+json":{"type":"dataframe","variable_name":"df"}},"metadata":{},"execution_count":4}]},{"cell_type":"markdown","source":["After recommending by boolean mask, We fetch corresponding movies IDs"],"metadata":{"id":"l7id2_dPoNzB"}},{"cell_type":"code","source":["# example boolean mask\n","boolMask = np.array( [ i % 2 != 0 for i in range( len(df.loc[0]) ) ] )\n","boolMask"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"0qHWkIpQNnTm","executionInfo":{"status":"ok","timestamp":1714753328189,"user_tz":-180,"elapsed":10,"user":{"displayName":"Mostafa Touny","userId":"03224802388069779869"}},"outputId":"9bb0c990-5c23-4d8f-a25c-ba000e5c6239"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["array([False,  True, False, ..., False,  True, False])"]},"metadata":{},"execution_count":48}]},{"cell_type":"code","source":["# array of movies IDs corresponding to the boolean mask\n","recommended_moviesIds = df.columns[boolMask].astype(int)"],"metadata":{"id":"TvkOPGT8ODbz"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":["# dataset for movieIds with their titles\n","df_mov = pd.read_csv(\"/content/drive/MyDrive/Spring 2024 - Math with Applications/MTH106 Linear Algebra/Project/movies.csv\")\n","df_mov"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":423},"id":"WKOpM7LGlj_1","executionInfo":{"status":"ok","timestamp":1714753039451,"user_tz":-180,"elapsed":414,"user":{"displayName":"Mostafa Touny","userId":"03224802388069779869"}},"outputId":"859dde0f-bbb3-4192-8dbc-27b2a9f7b19f"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["      movieId                                      title  \\\n","0           1                           Toy Story (1995)   \n","1           2                             Jumanji (1995)   \n","2           3                    Grumpier Old Men (1995)   \n","3           4                   Waiting to Exhale (1995)   \n","4           5         Father of the Bride Part II (1995)   \n","...       ...                                        ...   \n","9737   193581  Black Butler: Book of the Atlantic (2017)   \n","9738   193583               No Game No Life: Zero (2017)   \n","9739   193585                               Flint (2017)   \n","9740   193587        Bungo Stray Dogs: Dead Apple (2018)   \n","9741   193609        Andrew Dice Clay: Dice Rules (1991)   \n","\n","                                           genres  \n","0     Adventure|Animation|Children|Comedy|Fantasy  \n","1                      Adventure|Children|Fantasy  \n","2                                  Comedy|Romance  \n","3                            Comedy|Drama|Romance  \n","4                                          Comedy  \n","...                                           ...  \n","9737              Action|Animation|Comedy|Fantasy  \n","9738                     Animation|Comedy|Fantasy  \n","9739                                        Drama  \n","9740                             Action|Animation  \n","9741                                       Comedy  \n","\n","[9742 rows x 3 columns]"],"text/html":["\n","  <div id=\"df-42fd8f6f-27b2-4c28-a743-79286b3706b6\" class=\"colab-df-container\">\n","    <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>movieId</th>\n","      <th>title</th>\n","      <th>genres</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>Toy Story (1995)</td>\n","      <td>Adventure|Animation|Children|Comedy|Fantasy</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2</td>\n","      <td>Jumanji (1995)</td>\n","      <td>Adventure|Children|Fantasy</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>3</td>\n","      <td>Grumpier Old Men (1995)</td>\n","      <td>Comedy|Romance</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>4</td>\n","      <td>Waiting to Exhale (1995)</td>\n","      <td>Comedy|Drama|Romance</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>5</td>\n","      <td>Father of the Bride Part II (1995)</td>\n","      <td>Comedy</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>9737</th>\n","      <td>193581</td>\n","      <td>Black Butler: Book of the Atlantic (2017)</td>\n","      <td>Action|Animation|Comedy|Fantasy</td>\n","    </tr>\n","    <tr>\n","      <th>9738</th>\n","      <td>193583</td>\n","      <td>No Game No Life: Zero (2017)</td>\n","      <td>Animation|Comedy|Fantasy</td>\n","    </tr>\n","    <tr>\n","      <th>9739</th>\n","      <td>193585</td>\n","      <td>Flint (2017)</td>\n","      <td>Drama</td>\n","    </tr>\n","    <tr>\n","      <th>9740</th>\n","      <td>193587</td>\n","      <td>Bungo Stray Dogs: Dead Apple (2018)</td>\n","      <td>Action|Animation</td>\n","    </tr>\n","    <tr>\n","      <th>9741</th>\n","      <td>193609</td>\n","      <td>Andrew Dice Clay: Dice Rules (1991)</td>\n","      <td>Comedy</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>9742 rows × 3 columns</p>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-42fd8f6f-27b2-4c28-a743-79286b3706b6')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-42fd8f6f-27b2-4c28-a743-79286b3706b6 button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-42fd8f6f-27b2-4c28-a743-79286b3706b6');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-83f6a7c3-8908-497b-a7ac-f8917a33c84e\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-83f6a7c3-8908-497b-a7ac-f8917a33c84e')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-83f6a7c3-8908-497b-a7ac-f8917a33c84e button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"],"application/vnd.google.colaboratory.intrinsic+json":{"type":"dataframe","variable_name":"df_mov","summary":"{\n  \"name\": \"df_mov\",\n  \"rows\": 9742,\n  \"fields\": [\n    {\n      \"column\": \"movieId\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 52160,\n        \"min\": 1,\n        \"max\": 193609,\n        \"num_unique_values\": 9742,\n        \"samples\": [\n          45635,\n          1373,\n          7325\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"title\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 9737,\n        \"samples\": [\n          \"Teenage Mutant Ninja Turtles (2014)\",\n          \"America's Sweethearts (2001)\",\n          \"Cast Away (2000)\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"genres\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 951,\n        \"samples\": [\n          \"Crime|Mystery|Romance|Thriller\",\n          \"Action|Adventure|Comedy|Western\",\n          \"Crime|Drama|Musical\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"}},"metadata":{},"execution_count":39}]},{"cell_type":"code","source":["# construct pandas dataframe\n","rec_df = pd.DataFrame({\n","    \"movieId\": recommended_moviesIds\n","})\n","rec_df"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":423},"id":"OXn2dA9how5P","executionInfo":{"status":"ok","timestamp":1714753067755,"user_tz":-180,"elapsed":282,"user":{"displayName":"Mostafa Touny","userId":"03224802388069779869"}},"outputId":"00e67487-7f84-4b19-fda0-164f7c9a2f96"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["      movieId\n","0           1\n","1           3\n","2           5\n","3           7\n","4           9\n","...       ...\n","4857   193565\n","4858   193571\n","4859   193579\n","4860   193583\n","4861   193587\n","\n","[4862 rows x 1 columns]"],"text/html":["\n","  <div id=\"df-8b29ca24-4dca-45ca-8097-1efaf7e2719d\" class=\"colab-df-container\">\n","    <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>movieId</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>3</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>5</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>7</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>9</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>4857</th>\n","      <td>193565</td>\n","    </tr>\n","    <tr>\n","      <th>4858</th>\n","      <td>193571</td>\n","    </tr>\n","    <tr>\n","      <th>4859</th>\n","      <td>193579</td>\n","    </tr>\n","    <tr>\n","      <th>4860</th>\n","      <td>193583</td>\n","    </tr>\n","    <tr>\n","      <th>4861</th>\n","      <td>193587</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>4862 rows × 1 columns</p>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-8b29ca24-4dca-45ca-8097-1efaf7e2719d')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-8b29ca24-4dca-45ca-8097-1efaf7e2719d button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-8b29ca24-4dca-45ca-8097-1efaf7e2719d');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-df0e4775-e419-4aff-8bfa-045a98f66616\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-df0e4775-e419-4aff-8bfa-045a98f66616')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-df0e4775-e419-4aff-8bfa-045a98f66616 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"],"application/vnd.google.colaboratory.intrinsic+json":{"type":"dataframe","variable_name":"rec_df","summary":"{\n  \"name\": \"rec_df\",\n  \"rows\": 4862,\n  \"fields\": [\n    {\n      \"column\": \"movieId\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 52183,\n        \"min\": 1,\n        \"max\": 193587,\n        \"num_unique_values\": 4862,\n        \"samples\": [\n          6415,\n          58870,\n          8813\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"}},"metadata":{},"execution_count":43}]},{"cell_type":"code","source":["# join recommended movies ids with df_mov dataframe\n","pd.merge(left=rec_df, right=df_mov, how='inner', on='movieId')"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":423},"id":"6cnN2DDpo25o","executionInfo":{"status":"ok","timestamp":1714753078326,"user_tz":-180,"elapsed":325,"user":{"displayName":"Mostafa Touny","userId":"03224802388069779869"}},"outputId":"1e3823fe-e55f-46fe-8cc0-832ad5f9f0c3"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["      movieId                                     title  \\\n","0           1                          Toy Story (1995)   \n","1           3                   Grumpier Old Men (1995)   \n","2           5        Father of the Bride Part II (1995)   \n","3           7                            Sabrina (1995)   \n","4           9                       Sudden Death (1995)   \n","...       ...                                       ...   \n","4857   193565                 Gintama: The Movie (2010)   \n","4858   193571                       Silver Spoon (2014)   \n","4859   193579  Jon Stewart Has Left the Building (2015)   \n","4860   193583              No Game No Life: Zero (2017)   \n","4861   193587       Bungo Stray Dogs: Dead Apple (2018)   \n","\n","                                           genres  \n","0     Adventure|Animation|Children|Comedy|Fantasy  \n","1                                  Comedy|Romance  \n","2                                          Comedy  \n","3                                  Comedy|Romance  \n","4                                          Action  \n","...                                           ...  \n","4857               Action|Animation|Comedy|Sci-Fi  \n","4858                                 Comedy|Drama  \n","4859                                  Documentary  \n","4860                     Animation|Comedy|Fantasy  \n","4861                             Action|Animation  \n","\n","[4862 rows x 3 columns]"],"text/html":["\n","  <div id=\"df-9b461964-dbf3-4c35-b20f-a98c3758b653\" class=\"colab-df-container\">\n","    <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>movieId</th>\n","      <th>title</th>\n","      <th>genres</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>Toy Story (1995)</td>\n","      <td>Adventure|Animation|Children|Comedy|Fantasy</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>3</td>\n","      <td>Grumpier Old Men (1995)</td>\n","      <td>Comedy|Romance</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>5</td>\n","      <td>Father of the Bride Part II (1995)</td>\n","      <td>Comedy</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>7</td>\n","      <td>Sabrina (1995)</td>\n","      <td>Comedy|Romance</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>9</td>\n","      <td>Sudden Death (1995)</td>\n","      <td>Action</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>4857</th>\n","      <td>193565</td>\n","      <td>Gintama: The Movie (2010)</td>\n","      <td>Action|Animation|Comedy|Sci-Fi</td>\n","    </tr>\n","    <tr>\n","      <th>4858</th>\n","      <td>193571</td>\n","      <td>Silver Spoon (2014)</td>\n","      <td>Comedy|Drama</td>\n","    </tr>\n","    <tr>\n","      <th>4859</th>\n","      <td>193579</td>\n","      <td>Jon Stewart Has Left the Building (2015)</td>\n","      <td>Documentary</td>\n","    </tr>\n","    <tr>\n","      <th>4860</th>\n","      <td>193583</td>\n","      <td>No Game No Life: Zero (2017)</td>\n","      <td>Animation|Comedy|Fantasy</td>\n","    </tr>\n","    <tr>\n","      <th>4861</th>\n","      <td>193587</td>\n","      <td>Bungo Stray Dogs: Dead Apple (2018)</td>\n","      <td>Action|Animation</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>4862 rows × 3 columns</p>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-9b461964-dbf3-4c35-b20f-a98c3758b653')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-9b461964-dbf3-4c35-b20f-a98c3758b653 button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-9b461964-dbf3-4c35-b20f-a98c3758b653');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-84534c32-84f7-4218-8645-830e2359b9fd\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-84534c32-84f7-4218-8645-830e2359b9fd')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-84534c32-84f7-4218-8645-830e2359b9fd button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"],"application/vnd.google.colaboratory.intrinsic+json":{"type":"dataframe","summary":"{\n  \"name\": \"pd\",\n  \"rows\": 4862,\n  \"fields\": [\n    {\n      \"column\": \"movieId\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 52183,\n        \"min\": 1,\n        \"max\": 193587,\n        \"num_unique_values\": 4862,\n        \"samples\": [\n          6415,\n          58870,\n          8813\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"title\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 4860,\n        \"samples\": [\n          \"Intervista (1987)\",\n          \"Shine a Light (2008)\",\n          \"We Don't Live Here Anymore (2004)\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"genres\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 657,\n        \"samples\": [\n          \"Horror|Sci-Fi|Western\",\n          \"Drama|Film-Noir|Mystery|Romance\",\n          \"Animation|Children|Comedy\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"}},"metadata":{},"execution_count":44}]},{"cell_type":"code","source":["# join recommended movies ids with titles only\n","pd.merge(left=rec_df, right=df_mov[ [\"movieId\", \"title\"] ], how='inner', on='movieId')"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":423},"id":"qmanXOmbpYNo","executionInfo":{"status":"ok","timestamp":1714753084256,"user_tz":-180,"elapsed":11,"user":{"displayName":"Mostafa Touny","userId":"03224802388069779869"}},"outputId":"6030579c-e953-46e9-c600-853397795759"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["      movieId                                     title\n","0           1                          Toy Story (1995)\n","1           3                   Grumpier Old Men (1995)\n","2           5        Father of the Bride Part II (1995)\n","3           7                            Sabrina (1995)\n","4           9                       Sudden Death (1995)\n","...       ...                                       ...\n","4857   193565                 Gintama: The Movie (2010)\n","4858   193571                       Silver Spoon (2014)\n","4859   193579  Jon Stewart Has Left the Building (2015)\n","4860   193583              No Game No Life: Zero (2017)\n","4861   193587       Bungo Stray Dogs: Dead Apple (2018)\n","\n","[4862 rows x 2 columns]"],"text/html":["\n","  <div id=\"df-62ef407e-0241-47ba-9832-726de169b6ac\" class=\"colab-df-container\">\n","    <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>movieId</th>\n","      <th>title</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>Toy Story (1995)</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>3</td>\n","      <td>Grumpier Old Men (1995)</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>5</td>\n","      <td>Father of the Bride Part II (1995)</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>7</td>\n","      <td>Sabrina (1995)</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>9</td>\n","      <td>Sudden Death (1995)</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>4857</th>\n","      <td>193565</td>\n","      <td>Gintama: The Movie (2010)</td>\n","    </tr>\n","    <tr>\n","      <th>4858</th>\n","      <td>193571</td>\n","      <td>Silver Spoon (2014)</td>\n","    </tr>\n","    <tr>\n","      <th>4859</th>\n","      <td>193579</td>\n","      <td>Jon Stewart Has Left the Building (2015)</td>\n","    </tr>\n","    <tr>\n","      <th>4860</th>\n","      <td>193583</td>\n","      <td>No Game No Life: Zero (2017)</td>\n","    </tr>\n","    <tr>\n","      <th>4861</th>\n","      <td>193587</td>\n","      <td>Bungo Stray Dogs: Dead Apple (2018)</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>4862 rows × 2 columns</p>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-62ef407e-0241-47ba-9832-726de169b6ac')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-62ef407e-0241-47ba-9832-726de169b6ac button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-62ef407e-0241-47ba-9832-726de169b6ac');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-60ad0dbe-533e-413b-ac94-2cf955163c6d\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-60ad0dbe-533e-413b-ac94-2cf955163c6d')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-60ad0dbe-533e-413b-ac94-2cf955163c6d button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"],"application/vnd.google.colaboratory.intrinsic+json":{"type":"dataframe","summary":"{\n  \"name\": \"pd\",\n  \"rows\": 4862,\n  \"fields\": [\n    {\n      \"column\": \"movieId\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 52183,\n        \"min\": 1,\n        \"max\": 193587,\n        \"num_unique_values\": 4862,\n        \"samples\": [\n          6415,\n          58870,\n          8813\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"title\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 4860,\n        \"samples\": [\n          \"Intervista (1987)\",\n          \"Shine a Light (2008)\",\n          \"We Don't Live Here Anymore (2004)\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"}},"metadata":{},"execution_count":45}]},{"cell_type":"code","source":["# as python list\n","rec_str = pd.merge(left=rec_df, right=df_mov[ [\"movieId\", \"title\"] ], how=\"inner\", on=\"movieId\")\n","rec_str[\"title\"].to_list()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"ZptJOpPypr9e","executionInfo":{"status":"ok","timestamp":1714753088381,"user_tz":-180,"elapsed":349,"user":{"displayName":"Mostafa Touny","userId":"03224802388069779869"}},"outputId":"289d9781-efc6-4a09-9c90-9ad6fa1f7919"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["['Toy Story (1995)',\n"," 'Grumpier Old Men (1995)',\n"," 'Father of the Bride Part II (1995)',\n"," 'Sabrina (1995)',\n"," 'Sudden Death (1995)',\n"," 'American President, The (1995)',\n"," 'Balto (1995)',\n"," 'Cutthroat Island (1995)',\n"," 'Sense and Sensibility (1995)',\n"," 'Ace Ventura: When Nature Calls (1995)',\n"," 'Get Shorty (1995)',\n"," 'Assassins (1995)',\n"," 'Leaving Las Vegas (1995)',\n"," 'Now and Then (1995)',\n"," 'City of Lost Children, The (Cité des enfants perdus, La) (1995)',\n"," 'Dangerous Minds (1995)',\n"," 'Babe (1995)',\n"," 'It Takes Two (1995)',\n"," 'Cry, the Beloved Country (1995)',\n"," 'Dead Presidents (1995)',\n"," 'Mortal Kombat (1995)',\n"," 'How to Make an American Quilt (1995)',\n"," 'Pocahontas (1995)',\n"," 'Usual Suspects, The (1995)',\n"," 'Lamerica (1994)',\n"," 'Georgia (1995)',\n"," 'Postman, The (Postino, Il) (1994)',\n"," 'Eye for an Eye (1996)',\n"," \"Don't Be a Menace to South Central While Drinking Your Juice in the Hood (1996)\",\n"," 'Bio-Dome (1996)',\n"," 'French Twist (Gazon maudit) (1995)',\n"," 'From Dusk Till Dawn (1996)',\n"," 'Kicking and Screaming (1995)',\n"," 'Bed of Roses (1996)',\n"," 'Screamers (1995)',\n"," 'Crossing Guard, The (1995)',\n"," 'White Balloon, The (Badkonake sefid) (1995)',\n"," \"Antonia's Line (Antonia) (1995)\",\n"," 'Angels and Insects (1995)',\n"," 'Dunston Checks In (1996)',\n"," 'Nick of Time (1995)',\n"," 'Vampire in Brooklyn (1995)',\n"," 'Broken Arrow (1996)',\n"," 'Hate (Haine, La) (1995)',\n"," 'City Hall (1996)',\n"," 'Mr. Wrong (1996)',\n"," 'Happy Gilmore (1996)',\n"," 'Nobody Loves Me (Keiner liebt mich) (1994)',\n"," 'Catwalk (1996)',\n"," 'Taxi Driver (1976)',\n"," 'Before and After (1996)',\n"," \"Young Poisoner's Handbook, The (1995)\",\n"," 'Steal Big, Steal Little (1995)',\n"," 'Boomerang (1992)',\n"," 'Flirting With Disaster (1996)',\n"," \"Jupiter's Wife (1994)\",\n"," 'Jade (1995)',\n"," 'Man of the Year (1995)',\n"," 'Birdcage, The (1996)',\n"," 'Bad Boys (1995)',\n"," 'Basketball Diaries, The (1995)',\n"," 'Amateur (1994)',\n"," 'Rob Roy (1995)',\n"," 'Batman Forever (1995)',\n"," 'Beyond Rangoon (1995)',\n"," 'Canadian Bacon (1995)',\n"," 'Clockers (1995)',\n"," 'Crimson Tide (1995)',\n"," 'Desperado (1995)',\n"," 'Die Hard: With a Vengeance (1995)',\n"," 'First Knight (1995)',\n"," 'Hackers (1995)',\n"," 'Johnny Mnemonic (1995)',\n"," 'Jury Duty (1995)',\n"," 'Living in Oblivion (1995)',\n"," 'Love & Human Remains (1993)',\n"," 'Mallrats (1995)',\n"," 'Mute Witness (1994)',\n"," 'Net, The (1995)',\n"," 'Party Girl (1995)',\n"," 'Reckless (1995)',\n"," 'Scarlet Letter, The (1995)',\n"," 'Smoke (1995)',\n"," 'Species (1995)',\n"," 'Umbrellas of Cherbourg, The (Parapluies de Cherbourg, Les) (1964)',\n"," 'Total Eclipse (1995)',\n"," 'Under Siege 2: Dark Territory (1995)',\n"," 'Unzipped (1995)',\n"," 'Waterworld (1995)',\n"," 'Wild Bill (1995)',\n"," 'Bushwhacked (1995)',\n"," 'Before the Rain (Pred dozhdot) (1994)',\n"," 'Billy Madison (1995)',\n"," 'Boys on the Side (1995)',\n"," 'Castle Freak (1995)',\n"," 'Clerks (1994)',\n"," 'Disclosure (1994)',\n"," 'Destiny Turns on the Radio (1995)',\n"," 'Dolores Claiborne (1995)',\n"," 'Eat Drink Man Woman (Yin shi nan nu) (1994)',\n"," 'Exit to Eden (1994)',\n"," 'French Kiss (1995)',\n"," 'Far From Home: The Adventures of Yellow Dog (1995)',\n"," 'Hideaway (1995)',\n"," 'Farinelli: il castrato (1994)',\n"," 'Hoop Dreams (1994)',\n"," 'Houseguest (1994)',\n"," 'Heavyweights (Heavy Weights) (1995)',\n"," 'I.Q. (1994)',\n"," 'Jefferson in Paris (1995)',\n"," 'Junior (1994)',\n"," \"Kid in King Arthur's Court, A (1995)\",\n"," 'Star Wars: Episode IV - A New Hope (1977)',\n"," 'Little Princess, A (1995)',\n"," 'Like Water for Chocolate (Como agua para chocolate) (1992)',\n"," 'Major Payne (1995)',\n"," 'Love Affair (1994)',\n"," 'Madness of King George, The (1994)',\n"," 'Man of the House (1995)',\n"," 'Milk Money (1994)',\n"," 'Miami Rhapsody (1995)',\n"," 'Murder in the First (1995)',\n"," 'Nell (1994)',\n"," 'New York Cop (Nyû Yôku no koppu) (1993)',\n"," 'Nina Takes a Lover (1994)',\n"," 'Only You (1994)',\n"," 'Poison Ivy II (1996)',\n"," 'Léon: The Professional (a.k.a. The Professional) (Léon) (1994)',\n"," \"Pyromaniac's Love Story, A (1995)\",\n"," 'Pushing Hands (Tui shou) (1992)',\n"," 'Quiz Show (1994)',\n"," 'Queen Margot (Reine Margot, La) (1994)',\n"," 'Roommates (1995)',\n"," 'Three Colors: Red (Trois couleurs: Rouge) (1994)',\n"," 'Three Colors: White (Trzy kolory: Bialy) (1994)',\n"," 'Relative Fear (1994)',\n"," 'Swan Princess, The (1994)',\n"," 'Specialist, The (1994)',\n"," 'Santa Clause, The (1994)',\n"," 'Shallow Grave (1994)',\n"," 'Strawberry and Chocolate (Fresa y chocolate) (1993)',\n"," 'Sum of Us, The (1994)',\n"," 'To Live (Huozhe) (1994)',\n"," 'Tales from the Crypt Presents: Demon Knight (1995)',\n"," 'Tales from the Hood (1995)',\n"," 'Village of the Damned (1995)',\n"," 'Vanya on 42nd Street (1994)',\n"," 'Walking Dead, The (1995)',\n"," 'Virtuosity (1995)',\n"," 'War, The (1994)',\n"," \"Muriel's Wedding (1994)\",\n"," 'Ace Ventura: Pet Detective (1994)',\n"," 'Backbeat (1993)',\n"," 'Bullets Over Broadway (1994)',\n"," 'Client, The (1994)',\n"," 'Crooklyn (1994)',\n"," 'Cobb (1994)',\n"," 'Forrest Gump (1994)',\n"," 'Higher Learning (1995)',\n"," 'I Love Trouble (1994)',\n"," 'Jungle Book, The (1994)',\n"," 'Lion King, The (1994)',\n"," \"Wes Craven's New Nightmare (Nightmare on Elm Street Part 7: Freddy's Finale, A) (1994)\",\n"," 'Maverick (1994)',\n"," 'Naked Gun 33 1/3: The Final Insult (1994)',\n"," 'Reality Bites (1994)',\n"," 'Richie Rich (1994)',\n"," 'Speed (1994)',\n"," 'Timecop (1994)',\n"," 'When a Man Loves a Woman (1994)',\n"," 'Wyatt Earp (1994)',\n"," 'Man of No Importance, A (1994)',\n"," 'Low Down Dirty Shame, A (1994)',\n"," 'Colonel Chabert, Le (1994)',\n"," \"Jason's Lyric (1994)\",\n"," 'Highlander III: The Sorcerer (a.k.a. Highlander: The Final Dimension) (1994)',\n"," 'In the Mouth of Madness (1995)',\n"," 'Above the Rim (1994)',\n"," 'Age of Innocence, The (1993)',\n"," 'Air Up There, The (1994)',\n"," 'Bad Girls (1994)',\n"," 'Being Human (1993)',\n"," 'Beverly Hills Cop III (1994)',\n"," 'Blink (1994)',\n"," 'Blue Chips (1994)',\n"," 'Body Snatchers (1993)',\n"," 'Bronx Tale, A (1993)',\n"," 'Calendar Girl (1993)',\n"," \"City Slickers II: The Legend of Curly's Gold (1994)\",\n"," 'Cliffhanger (1993)',\n"," 'Color of Night (1994)',\n"," 'Cowboy Way, The (1994)',\n"," 'Dazed and Confused (1993)',\n"," 'Even Cowgirls Get the Blues (1993)',\n"," 'Farewell My Concubine (Ba wang bie ji) (1993)',\n"," 'Fear of a Black Hat (1994)',\n"," 'Flesh and Bone (1993)',\n"," 'For Love or Money (1993)',\n"," 'Free Willy (1993)',\n"," 'Fugitive, The (1993)',\n"," 'Getaway, The (1994)',\n"," 'Go Fish (1994)',\n"," 'Hot Shots! Part Deux (1993)',\n"," 'Englishman Who Went Up a Hill But Came Down a Mountain, The (1995)',\n"," 'House Party 3 (1994)',\n"," \"I'll Do Anything (1994)\",\n"," 'In the Line of Fire (1993)',\n"," 'Inkwell, The (1994)',\n"," 'Jimmy Hollywood (1994)',\n"," 'Jurassic Park (1993)',\n"," 'Killing Zoe (1994)',\n"," 'Last Action Hero (1993)',\n"," 'Lightning Jack (1994)',\n"," 'Made in America (1993)',\n"," 'Man Without a Face, The (1993)',\n"," 'Menace II Society (1993)',\n"," 'In the Realm of the Senses (Ai no corrida) (1976)',\n"," 'Much Ado About Nothing (1993)',\n"," 'Mrs. Doubtfire (1993)',\n"," 'Next Karate Kid, The (1994)',\n"," 'North (1994)',\n"," 'Perfect World, A (1993)',\n"," 'Piano, The (1993)',\n"," 'Program, The (1993)',\n"," 'Radioland Murders (1994)',\n"," 'Remains of the Day, The (1993)',\n"," 'Rising Sun (1993)',\n"," 'RoboCop 3 (1993)',\n"," 'Romeo Is Bleeding (1993)',\n"," 'Ruby in Paradise (1993)',\n"," 'Savage Nights (Nuits fauves, Les) (1992)',\n"," 'Scout, The (1994)',\n"," 'Secret Garden, The (1993)',\n"," 'Shadow, The (1994)',\n"," 'Short Cuts (1993)',\n"," 'Sirens (1994)',\n"," 'Sleepless in Seattle (1993)',\n"," 'Blade Runner (1982)',\n"," 'So I Married an Axe Murderer (1993)',\n"," 'Super Mario Bros. (1993)',\n"," 'Terminal Velocity (1994)',\n"," 'Threesome (1994)',\n"," 'Three Musketeers, The (1993)',\n"," 'True Romance (1993)',\n"," 'Pagemaster, The (1994)',\n"," 'Germinal (1993)',\n"," 'Kika (1993)',\n"," 'Little Big League (1994)',\n"," 'Spanking the Monkey (1994)',\n"," 'Andre (1994)',\n"," 'Princess Caraboo (1994)',\n"," 'Dear Diary (Caro Diario) (1994)',\n"," 'Home Alone (1990)',\n"," 'Aladdin (1992)',\n"," 'Dances with Wolves (1990)',\n"," 'Silence of the Lambs, The (1991)',\n"," 'Beauty and the Beast (1991)',\n"," 'Pretty Woman (1990)',\n"," 'Love and a .45 (1994)',\n"," 'One Fine Day (1996)',\n"," 'Fargo (1996)',\n"," 'Heavy Metal (1981)',\n"," 'Pallbearer, The (1996)',\n"," 'Bread and Chocolate (Pane e cioccolata) (1973)',\n"," 'Flower of My Secret, The (La flor de mi secreto) (1995)',\n"," 'Ed (1996)',\n"," 'Last Supper, The (1995)',\n"," 'All Dogs Go to Heaven 2 (1996)',\n"," 'Denise Calls Up (1995)',\n"," 'Family Thing, A (1996)',\n"," 'Sgt. Bilko (1996)',\n"," 'Girl 6 (1996)',\n"," 'Nelly & Monsieur Arnaud (1995)',\n"," 'Mission: Impossible (1996)',\n"," 'Moll Flanders (1996)',\n"," 'Eddie (1996)',\n"," 'Fear (1996)',\n"," 'Underground (1995)',\n"," 'Song of the Little Road (Pather Panchali) (1955)',\n"," 'Mystery Science Theater 3000: The Movie (1996)',\n"," 'Barbarella (1968)',\n"," 'Run of the Country, The (1995)',\n"," \"It's My Party (1996)\",\n"," 'Mrs. Winterbourne (1996)',\n"," 'Substitute, The (1996)',\n"," 'Feeling Minnesota (1996)',\n"," 'Angus (1995)',\n"," 'Quest, The (1996)',\n"," 'Mulholland Falls (1996)',\n"," 'Oliver & Company (1988)',\n"," 'Flipper (1996)',\n"," 'Horseman on the Roof, The (Hussard sur le toit, Le) (1995)',\n"," 'Multiplicity (1996)',\n"," 'Haunted World of Edward D. Wood Jr., The (1996)',\n"," 'Great White Hype, The (1996)',\n"," 'Cold Comfort Farm (1995)',\n"," 'Rock, The (1996)',\n"," 'Twister (1996)',\n"," 'Ghost in the Shell (Kôkaku kidôtai) (1995)',\n"," 'Spy Hard (1996)',\n"," 'Stupids, The (1996)',\n"," 'Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb (1964)',\n"," 'Maya Lin: A Strong Clear Vision (1994)',\n"," 'Phantom, The (1996)',\n"," 'Heavy (1995)',\n"," 'I Shot Andy Warhol (1996)',\n"," 'Spirits of the Dead (1968)',\n"," \"'Til There Was You (1997)\",\n"," 'Stealing Beauty (1996)',\n"," 'Hunchback of Notre Dame, The (1996)',\n"," 'Kingpin (1996)',\n"," 'Nutty Professor, The (1996)',\n"," 'Last Klezmer: Leopold Kozlowski, His Life and Music, The (1994)',\n"," 'Daylight (1996)',\n"," 'Lone Star (1996)',\n"," 'Phenomenon (1996)',\n"," \"She's the One (1996)\",\n"," 'American Buffalo (1996)',\n"," 'Fled (1996)',\n"," 'Larger Than Life (1996)',\n"," 'Collector, The (La collectionneuse) (1967)',\n"," 'Adventures of Pinocchio, The (1996)',\n"," 'First Wives Club, The (1996)',\n"," 'High School High (1996)',\n"," 'Chain Reaction (1996)',\n"," 'Emma (1996)',\n"," 'House Arrest (1996)',\n"," 'Tales from the Crypt Presents: Bordello of Blood (1996)',\n"," 'Escape from L.A. (1996)',\n"," 'Tin Cup (1996)',\n"," 'Supercop (Police Story 3: Supercop) (Jing cha gu shi III: Chao ji jing cha) (1992)',\n"," 'Carpool (1996)',\n"," \"Gone Fishin' (1997)\",\n"," 'Supercop 2 (Project S) (Chao ji ji hua) (1993)',\n"," 'Island of Dr. Moreau, The (1996)',\n"," 'Trigger Effect, The (1996)',\n"," 'Bulletproof (1996)',\n"," '1-900 (06) (1994)',\n"," 'Twelfth Night (1996)',\n"," 'Wild Reeds (Les roseaux sauvages) (1994)',\n"," 'Philadelphia Story, The (1940)',\n"," 'American in Paris, An (1951)',\n"," \"Breakfast at Tiffany's (1961)\",\n"," 'Rear Window (1954)',\n"," 'Gaslight (1944)',\n"," 'North by Northwest (1959)',\n"," 'Some Like It Hot (1959)',\n"," 'Casablanca (1942)',\n"," 'My Fair Lady (1964)',\n"," 'Roman Holiday (1953)',\n"," 'Meet Me in St. Louis (1944)',\n"," 'Gone with the Wind (1939)',\n"," 'Sunset Blvd. (a.k.a. Sunset Boulevard) (1950)',\n"," '2001: A Space Odyssey (1968)',\n"," 'Women, The (1939)',\n"," 'Foreign Correspondent (1940)',\n"," 'Spellbound (1945)',\n"," 'To Catch a Thief (1955)',\n"," 'Band Wagon, The (1953)',\n"," 'Love in the Afternoon (1957)',\n"," 'Adventures of Robin Hood, The (1938)',\n"," 'Laura (1944)',\n"," 'Lost Horizon (1937)',\n"," 'To Be or Not to Be (1942)',\n"," 'Giant (1956)',\n"," 'Thin Man, The (1934)',\n"," 'Around the World in 80 Days (1956)',\n"," 'Mr. Smith Goes to Washington (1939)',\n"," 'Penny Serenade (1941)',\n"," 'Little Lord Fauntleroy (1936)',\n"," '39 Steps, The (1935)',\n"," 'African Queen, The (1951)',\n"," 'Cat on a Hot Tin Roof (1958)',\n"," 'Farewell to Arms, A (1932)',\n"," 'Dangerous Ground (1997)',\n"," 'Pompatus of Love, The (1996)',\n"," 'Bliss (1997)',\n"," 'Maximum Risk (1996)',\n"," 'Infinity (1996)',\n"," 'Last Man Standing (1996)',\n"," '2 Days in the Valley (1996)',\n"," 'Glimmer Man, The (1996)',\n"," 'Chamber, The (1996)',\n"," 'Davy Crockett, King of the Wild Frontier (1955)',\n"," 'Love Bug, The (1969)',\n"," 'Old Yeller (1957)',\n"," 'Pollyanna (1960)',\n"," 'Shaggy Dog, The (1959)',\n"," 'That Darn Cat! (1965)',\n"," 'Cool Runnings (1993)',\n"," 'Cinderella (1950)',\n"," 'Three Caballeros, The (1945)',\n"," 'Robin Hood: Prince of Thieves (1991)',\n"," 'Dumbo (1941)',\n"," 'Bedknobs and Broomsticks (1971)',\n"," 'Fox and the Hound, The (1981)',\n"," 'Sound of Music, The (1965)',\n"," 'Lawnmower Man, The (1992)',\n"," 'Secrets & Lies (1996)',\n"," 'To Gillian on Her 37th Birthday (1996)',\n"," 'Long Kiss Goodnight, The (1996)',\n"," 'Looking for Richard (1996)',\n"," 'Normal Life (1996)',\n"," 'Shadow Conspiracy (1997)',\n"," 'Everyone Says I Love You (1996)',\n"," 'Swingers (1996)',\n"," 'Aladdin and the King of Thieves (1996)',\n"," 'Crossfire (1947)',\n"," 'Sleeper (1973)',\n"," 'Fish Called Wanda, A (1988)',\n"," 'Victor/Victoria (1982)',\n"," 'Great Race, The (1965)',\n"," 'Old Man and the Sea, The (1958)',\n"," 'Dirty Dancing (1987)',\n"," 'Platoon (1986)',\n"," 'Basic Instinct (1992)',\n"," 'Crying Game, The (1992)',\n"," \"Sophie's Choice (1982)\",\n"," 'Christmas Carol, A (1938)',\n"," 'Top Gun (1986)',\n"," 'Streetcar Named Desire, A (1951)',\n"," 'Loser (1991)',\n"," 'Palookaville (1996)',\n"," 'Single Girl, A (Fille seule, La) (1995)',\n"," 'Drunks (1995)',\n"," 'Glory Daze (1995)',\n"," 'On Golden Pond (1981)',\n"," 'Drop Dead Fred (1991)',\n"," 'Fog, The (1980)',\n"," 'Howling, The (1980)',\n"," 'Manon of the Spring (Manon des sources) (1986)',\n"," 'Monty Python and the Holy Grail (1975)',\n"," 'Entertaining Angels: The Dorothy Day Story (1996)',\n"," 'When We Were Kings (1996)',\n"," 'Return of Martin Guerre, The (Retour de Martin Guerre, Le) (1982)',\n"," 'Children Are Watching Us, The (Bambini ci guardano, I) (1944)',\n"," 'Ruling Class, The (1972)',\n"," 'Dear God (1996)',\n"," 'Bob Roberts (1992)',\n"," 'Cook the Thief His Wife & Her Lover, The (1989)',\n"," 'Double Life of Veronique, The (Double Vie de Véronique, La) (1991)',\n"," 'Paths of Glory (1957)',\n"," 'Hear My Song (1991)',\n"," 'Mediterraneo (1991)',\n"," 'Sex, Lies, and Videotape (1989)',\n"," 'Strictly Ballroom (1992)',\n"," 'Tie Me Up! Tie Me Down! (¡Átame!) (1990)',\n"," 'Paris Is Burning (1990)',\n"," \"Cheech and Chong's Up in Smoke (1978)\",\n"," 'Princess Bride, The (1987)',\n"," 'Brazil (1985)',\n"," 'Good, the Bad and the Ugly, The (Buono, il brutto, il cattivo, Il) (1966)',\n"," '12 Angry Men (1957)',\n"," 'Clockwork Orange, A (1971)',\n"," 'Apocalypse Now (1979)',\n"," 'Star Wars: Episode VI - Return of the Jedi (1983)',\n"," 'Third Man, The (1949)',\n"," 'Alien (1979)',\n"," 'Big Blue, The (Grand bleu, Le) (1988)',\n"," 'Killer, The (Die xue shuang xiong) (1989)',\n"," 'Blues Brothers, The (1980)',\n"," 'Full Metal Jacket (1987)',\n"," 'Henry V (1989)',\n"," 'Quiet Man, The (1952)',\n"," 'Raging Bull (1980)',\n"," 'Right Stuff, The (1983)',\n"," 'Boot, Das (Boat, The) (1981)',\n"," 'Harold and Maude (1971)',\n"," 'Seventh Seal, The (Sjunde inseglet, Det) (1957)',\n"," 'Terminator, The (1984)',\n"," 'Glory (1989)',\n"," 'Manhattan (1979)',\n"," 'Dead Poets Society (1989)',\n"," 'Touch of Evil (1958)',\n"," 'Bridge on the River Kwai, The (1957)',\n"," 'Chinatown (1974)',\n"," 'Treasure of the Sierra Madre, The (1948)',\n"," 'Duck Soup (1933)',\n"," 'Shining, The (1980)',\n"," 'M (1931)',\n"," 'Great Escape, The (1963)',\n"," 'Diva (1981)',\n"," 'Unforgiven (1992)',\n"," 'Pump Up the Volume (1990)',\n"," 'Back to the Future (1985)',\n"," 'Patton (1970)',\n"," 'Akira (1988)',\n"," 'Cool Hand Luke (1967)',\n"," 'Young Frankenstein (1974)',\n"," 'Raise the Red Lantern (Da hong deng long gao gao gua) (1991)',\n"," 'Fantasia (1940)',\n"," 'Big Sleep, The (1946)',\n"," 'Somewhere in Time (1980)',\n"," 'This Is Spinal Tap (1984)',\n"," 'Some Kind of Wonderful (1987)',\n"," 'Being There (1979)',\n"," 'Unbearable Lightness of Being, The (1988)',\n"," 'Real Genius (1985)',\n"," 'Killing Fields, The (1984)',\n"," 'Forbidden Planet (1956)',\n"," 'Man Who Would Be King, The (1975)',\n"," 'Paris, Texas (1984)',\n"," 'When Harry Met Sally... (1989)',\n"," 'Female Perversions (1996)',\n"," 'Alien³ (a.k.a. Alien 3) (1992)',\n"," \"Amityville 1992: It's About Time (1992)\",\n"," 'Amityville: Dollhouse (1996)',\n"," 'Amityville II: The Possession (1982)',\n"," 'Amityville Curse, The (1990)',\n"," \"April Fool's Day (1986)\",\n"," 'Believers, The (1987)',\n"," 'Blob, The (1958)',\n"," 'Body Parts (1991)',\n"," \"Dracula (Bram Stoker's Dracula) (1992)\",\n"," 'Burnt Offerings (1976)',\n"," 'Cape Fear (1991)',\n"," 'Carrie (1976)',\n"," 'Nightmare on Elm Street, A (1984)',\n"," 'Vampire in Venice (Nosferatu a Venezia) (Nosferatu in Venice) (1986)',\n"," 'Blood and Wine (Blood & Wine) (1996)',\n"," 'Mirror Has Two Faces, The (1996)',\n"," 'Nightwatch (1997)',\n"," 'Shine (1996)',\n"," 'Jingle All the Way (1996)',\n"," \"Preacher's Wife, The (1996)\",\n"," 'Crucible, The (1996)',\n"," 'Die Hard 2 (1990)',\n"," 'Star Trek VI: The Undiscovered Country (1991)',\n"," 'Star Trek II: The Wrath of Khan (1982)',\n"," 'Star Trek IV: The Voyage Home (1986)',\n"," 'Young Guns (1988)',\n"," 'Grease (1978)',\n"," 'Marked for Death (1990)',\n"," 'Jaws (1975)',\n"," 'Jaws 3-D (1983)',\n"," 'Mars Attacks! (1996)',\n"," 'Jerry Maguire (1996)',\n"," 'Tin Men (1987)',\n"," 'Bastard Out of Carolina (1996)',\n"," \"Marvin's Room (1996)\",\n"," 'Beavis and Butt-Head Do America (1996)',\n"," 'Scream (1996)',\n"," 'Michael (1996)',\n"," \"Some Mother's Son (1996)\",\n"," 'Mother (1996)',\n"," 'Evita (1996)',\n"," 'Walkabout (1971)',\n"," 'Hearts and Minds (1996)',\n"," 'Zeus and Roxanne (1997)',\n"," 'Angel Baby (1995)',\n"," 'Underworld (1996)',\n"," 'Metro (1997)',\n"," \"Dante's Peak (1997)\",\n"," 'Amos & Andrew (1993)',\n"," 'Prefontaine (1997)',\n"," 'Kolya (Kolja) (1996)',\n"," 'Waiting for Guffman (1996)',\n"," 'SubUrbia (1997)',\n"," 'Fools Rush In (1997)',\n"," 'Absolute Power (1997)',\n"," \"Vegas Vacation (National Lampoon's Las Vegas Vacation) (1997)\",\n"," 'Rosewood (1997)',\n"," 'Booty Call (1997)',\n"," 'Jungle2Jungle (a.k.a. Jungle 2 Jungle) (1997)',\n"," 'Private Parts (1997)',\n"," 'Saint, The (1997)',\n"," 'Crash (1996)',\n"," 'Liar Liar (1997)',\n"," \"Devil's Own, The (1997)\",\n"," 'B*A*P*S (1997)',\n"," 'Turbo: A Power Rangers Movie (1997)',\n"," 'Double Team (1997)',\n"," 'Anaconda (1997)',\n"," 'Kissed (1996)',\n"," 'Paradise Road (1997)',\n"," 'Temptress Moon (Feng Yue) (1996)',\n"," 'Children of the Revolution (1996)',\n"," 'Breakdown (1997)',\n"," \"Fathers' Day (1997)\",\n"," 'Nowhere (1997)',\n"," 'Shall We Dance? (Shall We Dansu?) (1996)',\n"," 'Brassed Off (1996)',\n"," 'Ponette (1996)',\n"," 'Shiloh (1997)',\n"," 'Trial and Error (1997)',\n"," 'Con Air (1997)',\n"," 'Speed 2: Cruise Control (1997)',\n"," \"For Roseanna (Roseanna's Grave) (1997)\",\n"," 'Hercules (1997)',\n"," \"When the Cat's Away (Chacun cherche son chat) (1996)\",\n"," 'Face/Off (1997)',\n"," 'Men in Black (a.k.a. MIB) (1997)',\n"," 'Wild America (1997)',\n"," 'Contact (1997)',\n"," 'G.I. Jane (1997)',\n"," 'George of the Jungle (1997)',\n"," 'Event Horizon (1997)',\n"," 'Air Bud (1997)',\n"," 'In the Company of Men (1997)',\n"," 'Conspiracy Theory (1997)',\n"," 'Steel (1997)',\n"," 'Hoodlum (1997)',\n"," 'Mimic (1997)',\n"," 'Excess Baggage (1997)',\n"," 'Air Force One (1997)',\n"," 'Hunt for Red October, The (1990)',\n"," 'Kiss Me, Guido (1997)',\n"," 'In & Out (1997)',\n"," 'Peacemaker, The (1997)',\n"," 'Seven Years in Tibet (1997)',\n"," 'Soul Food (1997)',\n"," 'Thousand Acres, A (1997)',\n"," 'Fire Down Below (1997)',\n"," 'MatchMaker, The (1997)',\n"," \"Ulee's Gold (1997)\",\n"," 'Chasing Amy (1997)',\n"," 'Indian Summer (a.k.a. Alive & Kicking) (1996)',\n"," 'I Know What You Did Last Summer (1997)',\n"," 'RocketMan (a.k.a. Rocket Man) (1997)',\n"," 'House of Yes, The (1997)',\n"," 'Washington Square (1997)',\n"," 'Gattaca (1997)',\n"," 'Phantoms (1998)',\n"," 'Life Less Ordinary, A (1997)',\n"," \"Eve's Bayou (1997)\",\n"," 'Gang Related (1997)',\n"," 'Bean (1997)',\n"," 'Welcome to Sarajevo (1997)',\n"," 'Rainmaker, The (1997)',\n"," 'Witness (1985)',\n"," 'Starship Troopers (1997)',\n"," 'Joy Luck Club, The (1993)',\n"," 'Sliding Doors (1998)',\n"," 'Truman Show, The (1998)',\n"," 'Mrs. Dalloway (1997)',\n"," 'Red Corner (1997)',\n"," 'Anastasia (1997)',\n"," 'Alien: Resurrection (1997)',\n"," 'Apostle, The (1997)',\n"," 'Bent (1997)',\n"," 'Deconstructing Harry (1997)',\n"," 'For Richer or Poorer (1997)',\n"," 'Home Alone 3 (1997)',\n"," 'Mouse Hunt (1997)',\n"," 'Stranger in the House (1997)',\n"," 'Titanic (1997)',\n"," 'Postman, The (1997)',\n"," 'Jackie Brown (1997)',\n"," 'Mr. Magoo (1997)',\n"," 'Afterglow (1997)',\n"," 'Great Expectations (1998)',\n"," 'Senseless (1998)',\n"," 'Dark City (1998)',\n"," 'Half Baked (1998)',\n"," 'Shooting Fish (1997)',\n"," 'Four Days in September (O Que É Isso, Companheiro?) (1997)',\n"," 'Deep Rising (1998)',\n"," 'Replacement Killers, The (1998)',\n"," 'Night Flier (1997)',\n"," 'Wedding Singer, The (1998)',\n"," 'Palmetto (1998)',\n"," 'King of New York (1990)',\n"," 'U.S. Marshals (1998)',\n"," 'Love and Death on Long Island (1997)',\n"," 'Hush (1998)',\n"," 'Man in the Iron Mask, The (1998)',\n"," 'Wild Things (1998)',\n"," 'Cool, Dry Place, A (1998)',\n"," 'Primary Colors (1998)',\n"," 'Two Girls and a Guy (1997)',\n"," 'Homegrown (1998)',\n"," \"Barney's Great Adventure (1998)\",\n"," 'Chinese Box (1997)',\n"," 'Mercury Rising (1998)',\n"," 'City of Angels (1998)',\n"," 'Odd Couple II, The (1998)',\n"," 'He Got Game (1998)',\n"," 'Live Flesh (Carne trémula) (1997)',\n"," 'Borrowers, The (1997)',\n"," 'Kurt & Courtney (1998)',\n"," 'Mr. Nice Guy (Yat goh ho yan) (1997)',\n"," 'Character (Karakter) (1997)',\n"," 'Major League: Back to the Minors (1998)',\n"," 'Tarzan and the Lost City (1998)',\n"," 'Misérables, Les (1998)',\n"," 'Deep Impact (1998)',\n"," 'Godzilla (1998)',\n"," 'Fear and Loathing in Las Vegas (1998)',\n"," 'Almost Heroes (1998)',\n"," 'Insomnia (1997)',\n"," 'Perfect Murder, A (1998)',\n"," 'Six Days Seven Nights (1998)',\n"," 'High Art (1998)',\n"," 'Dream for an Insomniac (1996)',\n"," 'Mr. Jealousy (1997)',\n"," 'X-Files: Fight the Future, The (1998)',\n"," 'Dr. Dolittle (1998)',\n"," 'Picnic at Hanging Rock (1975)',\n"," \"Buffalo '66 (a.k.a. Buffalo 66) (1998)\",\n"," 'Lethal Weapon 4 (1998)',\n"," 'Small Soldiers (1998)',\n"," 'Whatever (1998)',\n"," 'Plan 9 from Outer Space (1959)',\n"," 'All Quiet on the Western Front (1930)',\n"," 'Grand Hotel (1932)',\n"," 'Great Ziegfeld, The (1936)',\n"," \"You Can't Take It with You (1938)\",\n"," 'Going My Way (1944)',\n"," 'Best Years of Our Lives, The (1946)',\n"," 'Hamlet (1948)',\n"," 'From Here to Eternity (1953)',\n"," 'Marty (1955)',\n"," 'Tom Jones (1963)',\n"," 'In the Heat of the Night (1967)',\n"," 'Midnight Cowboy (1969)',\n"," 'Rocky (1976)',\n"," 'Ordinary People (1980)',\n"," 'Terms of Endearment (1983)',\n"," 'Last Emperor, The (1987)',\n"," 'Driving Miss Daisy (1989)',\n"," 'Klute (1971)',\n"," 'Metropolitan (1990)',\n"," 'Breakfast Club, The (1985)',\n"," 'Nightmare on Elm Street 3: Dream Warriors, A (1987)',\n"," 'Nightmare on Elm Street 5: The Dream Child, A (1989)',\n"," 'Friday the 13th (1980)',\n"," 'Friday the 13th Part 3: 3D (1982)',\n"," 'Friday the 13th Part V: A New Beginning (1985)',\n"," 'Friday the 13th Part VII: The New Blood (1988)',\n"," 'Halloween (1978)',\n"," 'Halloween III: Season of the Witch (1982)',\n"," 'Halloween 5: The Revenge of Michael Myers (1989)',\n"," 'Prom Night IV: Deliver Us From Evil (1992)',\n"," \"Child's Play 2 (1990)\",\n"," 'Poltergeist (1982)',\n"," 'Poltergeist III (1988)',\n"," 'Exorcist II: The Heretic (1977)',\n"," 'Lethal Weapon (1987)',\n"," 'Lethal Weapon 3 (1992)',\n"," 'Gremlins 2: The New Batch (1990)',\n"," 'Mask of Zorro, The (1998)',\n"," 'This World, Then the Fireworks (1997)',\n"," 'Metropolis (1927)',\n"," 'Back to the Future Part III (1990)',\n"," 'Freaky Friday (1977)',\n"," 'Apple Dumpling Gang Rides Again, The (1979)',\n"," 'Bambi (1942)',\n"," 'Dangerous Liaisons (1988)',\n"," 'Last Temptation of Christ, The (1988)',\n"," 'Rapture, The (1991)',\n"," 'Disturbing Behavior (1998)',\n"," 'Saving Private Ryan (1998)',\n"," 'Black Cauldron, The (1985)',\n"," \"Blackbeard's Ghost (1968)\",\n"," 'Candleshoe (1977)',\n"," 'Computer Wore Tennis Shoes, The (1969)',\n"," 'D2: The Mighty Ducks (1994)',\n"," 'Devil and Max Devlin, The (1981)',\n"," 'Great Mouse Detective, The (1986)',\n"," 'Herbie Goes to Monte Carlo (1977)',\n"," 'Honey, I Blew Up the Kid (1992)',\n"," 'Hot Lead and Cold Feet (1978)',\n"," 'Incredible Journey, The (1963)',\n"," 'Parent Trap, The (1998)',\n"," 'Roger & Me (1989)',\n"," 'Out of the Past (1947)',\n"," 'Fanny and Alexander (Fanny och Alexander) (1982)',\n"," 'Tender Mercies (1983)',\n"," \"'burbs, The (1989)\",\n"," 'Night Porter, The (Portiere di notte, Il) (1974)',\n"," 'Blue Velvet (1986)',\n"," 'Jungle Book, The (1967)',\n"," 'Little Mermaid, The (1989)',\n"," 'Muppet Christmas Carol, The (1992)',\n"," '101 Dalmatians (One Hundred and One Dalmatians) (1961)',\n"," 'Popeye (1980)',\n"," 'Rescuers, The (1977)',\n"," 'Return of Jafar, The (1994)',\n"," 'Rocketeer, The (1991)',\n"," 'Sleeping Beauty (1959)',\n"," 'Son of Flubber (1963)',\n"," 'Splash (1984)',\n"," 'Tall Tale (1995)',\n"," 'Tron (1982)',\n"," 'Halloween H20: 20 Years Later (Halloween 7: The Revenge of Laurie Strode) (1998)',\n"," 'Jerk, The (1979)',\n"," 'Man with Two Brains, The (1983)',\n"," 'Outsiders, The (1983)',\n"," 'Lord of the Rings, The (1978)',\n"," 'Dead Zone, The (1983)',\n"," 'Needful Things (1993)',\n"," 'Children of the Corn (1984)',\n"," 'Addams Family, The (1991)',\n"," 'Snake Eyes (1998)',\n"," 'Autumn Sonata (Höstsonaten) (1978)',\n"," 'Adventures in Babysitting (1987)',\n"," 'Doctor Dolittle (1967)',\n"," \"Charlotte's Web (1973)\",\n"," 'Secret of NIMH, The (1982)',\n"," 'American Tail, An (1986)',\n"," 'Legend (1985)',\n"," 'Pretty in Pink (1986)',\n"," 'Clan of the Cave Bear, The (1986)',\n"," 'House II: The Second Story (1987)',\n"," 'Gods Must Be Crazy II, The (1989)',\n"," 'Avengers, The (1998)',\n"," 'Slums of Beverly Hills, The (1998)',\n"," 'Henry: Portrait of a Serial Killer (1986)',\n"," 'NeverEnding Story, The (1984)',\n"," 'Attack of the Killer Tomatoes! (1978)',\n"," 'Your Friends and Neighbors (1998)',\n"," 'Blade (1998)',\n"," 'Wrongfully Accused (1998)',\n"," 'Strike! (a.k.a. All I Wanna Do, The Hairy Bird) (1998)',\n"," 'Déjà Vu (1997)',\n"," 'Family Plot (1976)',\n"," 'Topaz (1969)',\n"," 'Marnie (1964)',\n"," 'Man Who Knew Too Much, The (1956)',\n"," 'I Confess (1953)',\n"," 'Stage Fright (1950)',\n"," 'Why Do Fools Fall In Love? (1998)',\n"," 'Untouchables, The (1987)',\n"," 'Knock Off (1998)',\n"," 'Lifeboat (1944)',\n"," 'Saboteur (1942)',\n"," 'Suspicion (1941)',\n"," 'Lady Vanishes, The (1938)',\n"," 'Secret Agent (1936)',\n"," 'Ring, The (1927)',\n"," 'Rounders (1998)',\n"," 'Simon Birch (1998)',\n"," 'My Bodyguard (1980)',\n"," 'Broadcast News (1987)',\n"," 'Working Girl (1988)',\n"," 'Say Anything... (1989)',\n"," 'Hero (1992)',\n"," 'Young Doctors in Love (1982)',\n"," 'No Small Affair (1984)',\n"," 'Wisdom (1986)',\n"," 'About Last Night... (1986)',\n"," \"We're No Angels (1989)\",\n"," \"Butcher's Wife, The (1991)\",\n"," 'Few Good Men, A (1992)',\n"," 'Permanent Midnight (1998)',\n"," 'Rush Hour (1998)',\n"," 'Ronin (1998)',\n"," 'Clay Pigeons (1998)',\n"," 'Pecker (1998)',\n"," 'Fiendish Plot of Dr. Fu Manchu, The (1980)',\n"," 'Thing, The (1982)',\n"," 'Stardust Memories (1980)',\n"," 'Overnight Delivery (1998)',\n"," 'Impostors, The (1998)',\n"," 'What Dreams May Come (1998)',\n"," 'Producers, The (1968)',\n"," 'My Cousin Vinny (1992)',\n"," 'Love Is the Devil (1998)',\n"," 'One Tough Cop (1998)',\n"," '2010: The Year We Make Contact (1984)',\n"," 'Elephant Man, The (1980)',\n"," \"Bride of Chucky (Child's Play 4) (1998)\",\n"," 'Happiness (1998)',\n"," 'Pleasantville (1998)',\n"," 'Cruise, The (1998)',\n"," 'Orgazmo (1997)',\n"," 'Vampires (1998)',\n"," 'Hands on a Hard Body (1996)',\n"," 'Belly (1998)',\n"," 'Siege, The (1998)',\n"," 'Elizabeth (1998)',\n"," 'I Still Know What You Did Last Summer (1998)',\n"," 'Meet Joe Black (1998)',\n"," 'Runaway Train (1985)',\n"," 'Pope of Greenwich Village, The (1984)',\n"," 'Mona Lisa (1986)',\n"," 'Nights of Cabiria (Notti di Cabiria, Le) (1957)',\n"," 'Enemy of the State (1998)',\n"," \"Bug's Life, A (1998)\",\n"," 'Central Station (Central do Brasil) (1998)',\n"," 'Waking Ned Devine (a.k.a. Waking Ned) (1998)',\n"," 'Pink Flamingos (1972)',\n"," 'Godzilla (Gojira) (1954)',\n"," 'King Kong vs. Godzilla (Kingukongu tai Gojira) (1962)',\n"," 'King Kong (1976)',\n"," 'Desperately Seeking Susan (1985)',\n"," 'Fletch (1985)',\n"," 'Red Sonja (1985)',\n"," 'Money Pit, The (1986)',\n"," 'Lifeforce (1985)',\n"," 'Police Academy 2: Their First Assignment (1985)',\n"," 'Police Academy 4: Citizens on Patrol (1987)',\n"," 'Police Academy 6: City Under Siege (1989)',\n"," 'Home Fries (1998)',\n"," 'Steam: The Turkish Bath (Hamam) (1997)',\n"," 'Little Voice (1998)',\n"," 'Jack Frost (1998)',\n"," 'Prince of Egypt, The (1998)',\n"," 'Shakespeare in Love (1998)',\n"," 'Santa Claus: The Movie (1985)',\n"," 'Pale Rider (1985)',\n"," 'First Blood (Rambo: First Blood) (1982)',\n"," 'Jewel of the Nile, The (1985)',\n"," 'Cocoon (1985)',\n"," 'Rocky II (1979)',\n"," 'Rocky IV (1985)',\n"," 'Clue (1985)',\n"," 'Violets Are Blue... (1986)',\n"," 'Heartburn (1986)',\n"," 'Extremities (1986)',\n"," 'Karate Kid, Part II, The (1986)',\n"," \"Christmas Vacation (National Lampoon's Christmas Vacation) (1989)\",\n"," 'General, The (1998)',\n"," 'Faculty, The (1998)',\n"," 'Mighty Joe Young (1949)',\n"," 'Stepmom (1998)',\n"," 'Hurlyburly (1998)',\n"," 'Affliction (1997)',\n"," 'Playing by Heart (1998)',\n"," 'In Dreams (1999)',\n"," 'Virus (1999)',\n"," 'Gate, The (1987)',\n"," 'Fly, The (1958)',\n"," 'Fly II, The (1989)',\n"," 'Armed and Dangerous (1986)',\n"," 'Texas Chainsaw Massacre 2, The (1986)',\n"," 'Ruthless People (1986)',\n"," 'Name of the Rose, The (Name der Rose, Der) (1986)',\n"," 'Peggy Sue Got Married (1986)',\n"," 'Crocodile Dundee II (1988)',\n"," 'Soul Man (1986)',\n"," '52 Pick-Up (1986)',\n"," 'Firewalker (1986)',\n"," 'My Name Is Joe (1998)',\n"," 'Day of the Beast, The (Día de la Bestia, El) (1995)',\n"," 'Peeping Tom (1960)',\n"," 'Simply Irresistible (1999)',\n"," 'Harmonists, The (1997)',\n"," 'Fantastic Planet, The (Planète sauvage, La) (1973)',\n"," 'Message in a Bottle (1999)',\n"," 'Jawbreaker (1999)',\n"," 'Office Space (1999)',\n"," '200 Cigarettes (1999)',\n"," 'Other Sister, The (1999)',\n"," 'Ballad of Narayama, The (Narayama bushiko) (1983)',\n"," 'Pet Sematary II (1992)',\n"," 'Children of the Corn III (1994)',\n"," 'Night Shift (1982)',\n"," 'Airport 1975 (1974)',\n"," 'Rollercoaster (1977)',\n"," 'Alligator (1980)',\n"," 'Westworld (1973)',\n"," 'Planet of the Apes (1968)',\n"," 'Battle for the Planet of the Apes (1973)',\n"," 'Escape from the Planet of the Apes (1971)',\n"," 'Earthquake (1974)',\n"," 'Dancemaker (1998)',\n"," 'Corruptor, The (1999)',\n"," 'Lock, Stock & Two Smoking Barrels (1998)',\n"," 'Deep End of the Ocean, The (1999)',\n"," 'Wing Commander (1999)',\n"," 'Dead Ringers (1988)',\n"," 'Village of the Damned (1960)',\n"," 'Baby Geniuses (1999)',\n"," 'Forces of Nature (1999)',\n"," 'Ravenous (1999)',\n"," 'Dangerous Beauty (1998)',\n"," \"Doug's 1st Movie (1999)\",\n"," 'Mod Squad, The (1999)',\n"," 'Matrix, The (1999)',\n"," 'Tango (1998)',\n"," 'Dreamlife of Angels, The (Vie rêvée des anges, La) (1998)',\n"," 'Following (1998)',\n"," 'Never Been Kissed (1999)',\n"," \"Cookie's Fortune (1999)\",\n"," 'Goodbye Lover (1999)',\n"," 'Friends & Lovers (1999)',\n"," 'Monster, The (Mostro, Il) (1994)',\n"," 'SLC Punk! (1998)',\n"," 'Pushing Tin (1999)',\n"," 'eXistenZ (1999)',\n"," 'Idle Hands (1999)',\n"," 'King of Masks, The (Bian Lian) (1996)',\n"," 'Mildred Pierce (1945)',\n"," 'Chopping Mall (a.k.a. Killbots) (1986)',\n"," 'Dick Tracy (1990)',\n"," 'Castle, The (1997)',\n"," \"William Shakespeare's A Midsummer Night's Dream (1999)\",\n"," 'After Life (Wandafuru raifu) (1998)',\n"," 'Star Wars: Episode I - The Phantom Menace (1999)',\n"," \"Besieged (a.k.a. L' Assedio) (1998)\",\n"," 'Mummy, The (1932)',\n"," 'Mommie Dearest (1981)',\n"," 'Superman II (1980)',\n"," 'Superman IV: The Quest for Peace (1987)',\n"," 'Frankenstein (1931)',\n"," 'Curse of Frankenstein, The (1957)',\n"," 'Howling II: Your Sister Is a Werewolf (1985)',\n"," 'Rocky Horror Picture Show, The (1975)',\n"," 'Thing from Another World, The (1951)',\n"," ...]"]},"metadata":{},"execution_count":46}]},{"cell_type":"markdown","source":["Numpy Matrix. Rows correspond to users and every column corresponds to a movie"],"metadata":{"id":"umLR1quWsqJB"}},{"cell_type":"code","source":["# first column (userId) is ignored\n","df.loc[:, '1':'193609']"],"metadata":{"id":"-x6J_-gYsvx0","colab":{"base_uri":"https://localhost:8080/","height":423},"executionInfo":{"status":"ok","timestamp":1712483934518,"user_tz":-120,"elapsed":445,"user":{"displayName":"Mostafa Touny","userId":"03224802388069779869"}},"outputId":"1fae3840-da23-4c27-a2df-900cf28b318d"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["       1    2    3   4   5    6    7   8   9   10  ...  193565  193567  \\\n","0    4.0  NaN  4.0 NaN NaN  4.0  NaN NaN NaN  NaN  ...     NaN     NaN   \n","1    NaN  NaN  NaN NaN NaN  NaN  NaN NaN NaN  NaN  ...     NaN     NaN   \n","2    NaN  NaN  NaN NaN NaN  NaN  NaN NaN NaN  NaN  ...     NaN     NaN   \n","3    NaN  NaN  NaN NaN NaN  NaN  NaN NaN NaN  NaN  ...     NaN     NaN   \n","4    4.0  NaN  NaN NaN NaN  NaN  NaN NaN NaN  NaN  ...     NaN     NaN   \n","..   ...  ...  ...  ..  ..  ...  ...  ..  ..  ...  ...     ...     ...   \n","605  2.5  NaN  NaN NaN NaN  NaN  2.5 NaN NaN  NaN  ...     NaN     NaN   \n","606  4.0  NaN  NaN NaN NaN  NaN  NaN NaN NaN  NaN  ...     NaN     NaN   \n","607  2.5  2.0  2.0 NaN NaN  NaN  NaN NaN NaN  4.0  ...     NaN     NaN   \n","608  3.0  NaN  NaN NaN NaN  NaN  NaN NaN NaN  4.0  ...     NaN     NaN   \n","609  5.0  NaN  NaN NaN NaN  5.0  NaN NaN NaN  NaN  ...     NaN     NaN   \n","\n","     193571  193573  193579  193581  193583  193585  193587  193609  \n","0       NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN  \n","1       NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN  \n","2       NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN  \n","3       NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN  \n","4       NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN  \n","..      ...     ...     ...     ...     ...     ...     ...     ...  \n","605     NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN  \n","606     NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN  \n","607     NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN  \n","608     NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN  \n","609     NaN     NaN     NaN     NaN     NaN     NaN     NaN     NaN  \n","\n","[610 rows x 9724 columns]"],"text/html":["\n","  <div id=\"df-97eeec98-764e-439d-8739-1c7ddbfa4d98\" class=\"colab-df-container\">\n","    <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>1</th>\n","      <th>2</th>\n","      <th>3</th>\n","      <th>4</th>\n","      <th>5</th>\n","      <th>6</th>\n","      <th>7</th>\n","      <th>8</th>\n","      <th>9</th>\n","      <th>10</th>\n","      <th>...</th>\n","      <th>193565</th>\n","      <th>193567</th>\n","      <th>193571</th>\n","      <th>193573</th>\n","      <th>193579</th>\n","      <th>193581</th>\n","      <th>193583</th>\n","      <th>193585</th>\n","      <th>193587</th>\n","      <th>193609</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>4.0</td>\n","      <td>NaN</td>\n","      <td>4.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>4.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>4.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>605</th>\n","      <td>2.5</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>2.5</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>606</th>\n","      <td>4.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>607</th>\n","      <td>2.5</td>\n","      <td>2.0</td>\n","      <td>2.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>4.0</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>608</th>\n","      <td>3.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>4.0</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>609</th>\n","      <td>5.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>5.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>610 rows × 9724 columns</p>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-97eeec98-764e-439d-8739-1c7ddbfa4d98')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-97eeec98-764e-439d-8739-1c7ddbfa4d98 button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-97eeec98-764e-439d-8739-1c7ddbfa4d98');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-c269e3e8-41ff-4fab-9cb5-5cdcea4c9df2\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-c269e3e8-41ff-4fab-9cb5-5cdcea4c9df2')\"\n","            title=\"Suggest charts\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-c269e3e8-41ff-4fab-9cb5-5cdcea4c9df2 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"],"application/vnd.google.colaboratory.intrinsic+json":{"type":"dataframe"}},"metadata":{},"execution_count":10}]},{"cell_type":"code","source":["#M = df.to_numpy()"],"metadata":{"id":"w8cklMUvQnf5"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":["# as a numpy 2d array excluding first column\n","df.loc[:, '1':'193609'].to_numpy()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"2vUtNPseucSK","executionInfo":{"status":"ok","timestamp":1712483934518,"user_tz":-120,"elapsed":12,"user":{"displayName":"Mostafa Touny","userId":"03224802388069779869"}},"outputId":"2c4708c1-0c7d-45d7-fb77-bb93d33b42b4"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["array([[4. , nan, 4. , ..., nan, nan, nan],\n","       [nan, nan, nan, ..., nan, nan, nan],\n","       [nan, nan, nan, ..., nan, nan, nan],\n","       ...,\n","       [2.5, 2. , 2. , ..., nan, nan, nan],\n","       [3. , nan, nan, ..., nan, nan, nan],\n","       [5. , nan, nan, ..., nan, nan, nan]])"]},"metadata":{},"execution_count":11}]},{"cell_type":"markdown","source":["## Task"],"metadata":{"id":"7dafXWCMujav"}},{"cell_type":"markdown","source":["- Check the data types, and modify them if needed.\n","- Fill _NaNs_ by a suitable value of your choice.\n","- Pick-up two users, and compute _Cosine Similarity_ and _Euclidean Distance_ between them."],"metadata":{"id":"71bY2KWZu-Z6"}}]}